Replication Archive for "Beyond the Classroom: The Implications of School Vouchers for Church Finances"
Dan Hungerman, Kevin Rinz, and Jay Frymark

Inventory
- ./Scripts/
	- 1.tract_covars.do: Collects tract-level measures for use in constructing independent variables 
	  used in regression analysis
	- 2.parish_covars.do: Generates parish-level measures from tract-level measures for tracts within 1, 2, 
	  and 3 miles of each parish, interpolates between Census/ACS years
	- 3.prepare_data.do: Creates combined datasets used in main regression analysis
	- 4.nccs_data.do: Prepares data for analysis of other nonprofits in Wisconsin
	- 5.tables_figures.do: Prepares data for regression analysis and generates tables and figures included in the paper

- ./Data/
	- ustracts2000.dta: DTA version of 2000 national census tracts gazeteer, downloaded from
	  https://www.census.gov/geo/maps-data/data/gazetteer2000.html
	- ustracts2010.dta: DTA version of 2010 national census tracts gazeteer, downloaded from
	  https://www.census.gov/geo/maps-data/data/gazetteer2010.html
	- Census Tract Covariates/raw.zip: Raw CSV files of tract-level characteristics, downloaded
	  from American Factfinder
	- Census Tract Covariates/For Stata/*.csv: Versions of factfinder CSVs modified and renamed
	  for easy Stata importing
	- wisconsin_tract_covars.dta: Tract-level measures of demographic characteristics
	- wisconsin_tract_fpl_shares_faminc_famtype.dta: Tract-level counts of families in bins
	  defined by income relative to poverty
	- prices.dta: CPI, series CPIAUCSL obtained from FRED
	- Voucher Enrollment and Spending/clean_panel_mpc.dta: data on enrollment and spending for
	  the Milwaukee Parental Choice Program, constructed from reports obtained from the Wisconsin
	  Department of Public Instruction website
	  (https://dpi.wi.gov/sms/choice-programs/data/mpcp-historical)
	- Voucher Enrollment and Spending/clean_panel_rpc.dta: data on enrollment and spending for
	  the Racine Parental Choice Program, constructed from reports obtained from the Wisconsin
	  Department of Public Instruction website
	  (https://dpi.wi.gov/sms/choice-programs/data/rpcp-historical)
	- Voucher Enrollment and Spending/clean_panel_wpc.dta: data on enrollment and spending for
	  the Wisconsin Parental Choice Program, constructed from reports obtained from the Wisconsin
	  Department of Public Instruction website
	  (https://dpi.wi.gov/sms/choice-programs/data/wpcp-historical)

- ./Output/
	- No files, included as destination directory of save/export commands in some scripts

- Files withheld in accordance with terms of data use agreements
	- wisconsin_school_parish_locations.dta: addresses, including latitude and longitude, for parishes/
	  schools in sample
	- wisconsin_school_covars_1miles.dta: parish/school-level demographic covariates based on tracts within 1 mile
	- wisconsin_school_covars_1miles_interp.dta: same as above, with values interpolated between Census
	  and ACS years
	- wisconsin_school_covars_2miles.dta: parish/school-level covariates based on tracts within 2 miles
	- wisconsin_school_covars_2miles_interp.dta: same as above, with values interpolated between Census
	  and ACS years
	- wisconsin_school_covars_3miles.dta: parish/school-level covariates based on tracts within 3 miles
	- wisconsin_school_covars_3miles_interp.dta: same as above, with values interpolated between Census
	  and ACS years
	- wisconsin_school_fpl_1miles_faminc_famtype.dta: parish/school-level counts of families in bins
	  defined by income relative to poverty based on tracts within 1 mile
	- wisconsin_school_fpl_1miles_faminc_famtype_interp.dta: same as above, with values interpolated
	  between Census and ACS years
	- wisconsin_school_fpl_2miles_faminc_famtype.dta: parish/school-level counts of families in bins
	  defined by income relative to poverty based on tracts within 2 miles
	- wisconsin_school_fpl_2miles_faminc_famtype_interp.dta: same as above, with values interpolated
	  between Census and ACS years
	- wisconsin_school_fpl_3miles_faminc_famtype.dta: parish/school-level counts of families in bins
	  defined by income relative to poverty based on tracts within 3 miles
	- wisconsin_school_fpl_3miles_faminc_famtype_interp.dta: same as above, with values interpolated
	  between Census and ACS years
	- voucher_catholic_xwalk.dta: crosswalk between school IDs in voucher enrollment and spending
	  data and parish IDs in parish financial data
	- Parish and School Addresses.xlsx: 
	- finances_treatgrp.dta: financial data for initially targeted group of parishes
	- finances_controlgrp.dta: financial data for additional parishes
	- parish_allegations_clean_with_id.dta: data on number of priests accused on sexual abuse
	  by parish and year
	- assembled_data_1mi.dta: combined data based on tracts within 1 mile of each parish/school
	- assembled_data_2mi.dta: combined data based on tracts within 2 miles of each parish/school
	- assembled_data_3mi.dta: combined data based on tracts within 3 miles of each parish/school
	- nccs_wi_YYYY.dta: data on nonprofit organizations in Wisconsin from the National Center for
	  Charitable Statistics (YYYY = 1999-2012)
	- nccs_panel*.dta: panelized data on other Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- nccs_raw_addresses*.dta: raw addresses of other Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- nccs_clean_addresses*.dta: clean addresses of other Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- nccs_latlon*.dta: latitudes and longitudes for other Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- nccs_panel_latlon*.dta: panelized data on other Wisconsin nonprofits with latitudes and longitudes
	  attached (* = [no value], _st, _small, _bx)
	- wisconsin_nccs*_fpl_1miles_faminc_famtype.dta: counts of families in bins defined by income relative
	  to poverty based on tracts within 1 mile of other Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- wisconsin_nccs*_covars_1miles.dta: demographic covariates based on tracts within 1 mile of other
	  Wisconsin nonprofits (* = [no value], _st, _small, _bx)
	- wisconsin_nccs*_covars_1miles_interp.dta: same as above, with values interpolated between Census
	  and ACS years (* = [no value], _st, _small, _bx)
	- nccs*_analysis_sample.dta: combined data based on tracts within 1 mile of each other Wisconsin
	  nonprofit (* = [no value], _st, _small, _bx)

Notes
- In order to obtain data from the Archdiocese of Milwaukee, the authors agreed not to disclose 
  information about participating parishes without their consent. Data on nonprofit organizations
  in Wisconsin were purchased from the National Center for Charitable Statistics and cannot be 
  redistributed. Files have been withheld from this archive that would either disclose the identities
  of participating parishes or would redistribute data purchased from NCCS. For more information on
  how to obtain permission to use the files withheld from this archive, contact the authors at
  dhungerm@nd.edu or kjrinz@gmail.com
- All analysis in this paper was conducted using Stata MP, version 13.1
- Code should be executed in the order indicated by the numbers in the names of the do files





Replication Details, by do file
- 1.tract_covars.do
	- Description: Collects tract-level measures for use in constructing independent variables 
	  used in regression analysis
	- Inputs: ustarcts2000.dta, ustracts2010.dta, Census Tract Covariates/For Stata/*.csv
	- Outputs: wisconsin_tract_covars.dta, wisconsin_tract_fpl_shares_faminc_famtype.dta

- 2.parish_covars.do
	- Description: Generates parish-level measures from tract-level measures for tracts within 1, 2, 
	  and 3 miles of each parish, interpolates between Census/ACS years
	- Inputs: ustarcts2000.dta, ustracts2010.dta, wisconsin_tract_covars.dta, 
	  wisconsin_school_parish_locations.dta, wisconsin_tract_fpl_shares_faminc_famtype.dta
	- Outputs: wisconsin_school_covars_1miles.dta, wisconsin_school_covars_2miles.dta,
	  wisconsin_school_covars_3miles.dta, wisconsin_school_fpl_1miles_faminc_famtype.dta,
	  wisconsin_school_fpl_2miles_faminc_famtype.dta, wisconsin_school_fpl_3miles_faminc_famtype.dta,
	  wisconsin_school_covars_1miles_interp.dta, wisconsin_school_fpl_1miles_faminc_famtype_interp.dta,
	  wisconsin_school_covars_2miles_interp.dta, wisconsin_school_fpl_2miles_faminc_famtype_interp.dta,
	  wisconsin_school_covars_3miles_interp.dta, wisconsin_school_fpl_3miles_faminc_famtype_interp.dta

- 3.prepare_data.do
	- Description: Creates combined datasets used in main regression analysis
	- Inputs: prices.dta, Voucher Enrollment and Spending/clean_panel_mpc.dta
	  Voucher Enrollment and Spending/clean_panel_rpc.dta, Voucher Enrollment and Spending/clean_panel_wpc.dta
	  voucher_catholic_xwalk.dta, Parish and School Addresses.xlsx,
	  wisconsin_school_covars_1miles_interp.dta, wisconsin_school_fpl_1miles_faminc_famtype_interp.dta,
	  wisconsin_school_covars_2miles_interp.dta, wisconsin_school_fpl_2miles_faminc_famtype_interp.dta,
	  wisconsin_school_covars_3miles_interp.dta, wisconsin_school_fpl_3miles_faminc_famtype_interp.dta,
	  finances_treatgrp.dta, finances_controlgrp.dta, parish_allegations_clean_with_id.dta
	- Outputs: assembled_data_1mi.dta, assembled_data_2mi.dta, assembled_data_3mi.dta,
	  assembled_data_1mi_mergers.dta

- 4.nccs_data.do
	- Description: Prepares data for analysis of other nonprofits in Wisconsin
	- Inputs: nccs_wi_YYYY.dta, ustracts2000.dta, ustracts2010.dta, wisconsin_tract_fpl_shares_faminc_famtype.dta,
	  wisconsin_tract_covars.dta,
	- Outputs: nccs_panel*.dta, nccs_clean_addresses*.dta, nccs_latlon*.dta, nccs_panel_latlon*.dta,
	  wisconsin_nccs*_fpl_1miles_faminc_famtype.dta, wisconsin_nccs*_covars_1miles.dta,
	  wisconsin_nccs*_covars_1miles_interp.dta, nccs*_analysis_sample.dta (* = [no value], _st, _small, _bx)

- 5.tables_figures.do
	- Description: Prepares data for regression analysis and generates tables and figures included in the paper
	- Inputs: assembled_data_1mi.dta, assembled_data_2mi.dta, assembled_data_3mi.dta, assembled_data_1mi_mergers.dta
	- Outputs: estimates used to construct all tables and figures in the paper